Table: Cheque Details

Table: CPCHKD
View: CP0049
Record length: 442
Flags: A R 

Keys: 2

Title  Flags  Fields

Employee   EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order   EMPLOYEE, PEREND, ENTRYSEQ, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

Fields: 47

Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee  Mask: %-12N
PEREND  Date  Period End Date   
ENTRYSEQ  Long  Entry Sequence By Employee   
CATEGORY  Integer  Category code  List: 10 entries
1=Accrual
2=Earning
3=Advance
4=Deduction
5=Expense Reimbursement
6=Benefit
7=Federal Tax
8=Provincial Tax
9=Local Tax
10=User Tax
EARNDED  String*6  Earnings/Deduction  Mask: %-6N
LINETYPE  Integer  Presentation List Type Pay  List: 9 entries
1=Payment
2=Accrual
3=Regular
4=Overtime
5=Shift Differential
6=n/a
7=Normal Withholding
8=Backup Withholding
9=Supplemental Withholding
LINENO  Integer  Unique Key Field   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
EARDEDTYPE  Integer  Earnings/Deduction Type  List: 16 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
7=Vacation
8=Sick
9=Banked Time
10=
13=Cash
14=Noncash
18=Insurance Tax
19=Income Tax
20=Employment Tax
21=Pension Plan Tax
22=Health Tax
23=Other Tax
25=n/a
EARDEDDATE  Date  Earnings/Deduction Date   
HOURS  BCD*4.3  Earnings/Deduction Hours   
ECNTBASE  BCD*10.3  Employee Amt, Cnt, Base or Sales   
ERATE  BCD*9.5  Employee Hourly Rate or Percent   
EEXTEND  BCD*10.3  Employee Dollar Amounts   
EREGRATE  BCD*9.5  Base Regular Rate for OT   
RCNTBASE  BCD*10.3  Employer Amt, Cnt, Base or Sales   
RRATE  BCD*9.5  Employer Hourly Rate or Percent   
REXTEND  BCD*10.3  Employer Dollar Amounts   
EXPACCT  String*45  Regular Pay Expense G/L Account   
ELIABACCT  String*45  Employee Liability G/L Account   
RLIABACCT  String*45  Employer Liability G/L Account   
WCC  String*6  Workers' Compensation Code   
GLSEG1  String*15  Cost Center Segment One   
GLSEG2  String*15  Cost Center Segment Two   
GLSEG3  String*15  Cost Center Segment Three   
PARTIAL  Boolean  Detail Was Partially Taken or No   
TAXWEEKS  BCD*4.3  Weeks Worked for the Taxing Auth   
TAXEARNS  BCD*10.3  Taxable Earnings   
TXEARNCEIL  BCD*10.3  Taxable Earnings Ceiling   
TAXTIPS  BCD*10.3  Taxable Tips Without a Ceiling   
TXTIPSCEIL  BCD*10.3  Taxable Tips With a Ceiling   
TAXONTIPS  BCD*10.3  Amount of Tax Calculated on Tips   
UNCOLLTAX  BCD*10.3  For Uncollected SS/Med   
PCATEGORY  Integer  Print Category  List: 5 entries
1=CHKD Earnings
2=CHKD Deductions
3=CHKD Taxes
4=CHKD Other
5=CHKD Benefits
PLINETYPE  Integer  Print Line Type  List: 42 entries
11=CHKD Regular Line
11=CHKD Overtime Line
11=CHKD Shift Diff Line
14=CHKD Disbursed Tips
15=CHKD Vacation Payment
16=CHKD Sick Payment
17=CHKD Comp. Time Payment
21=CHKD Deduction Entry
31=CHKD Federal Income Entry
32=CHKD Federal Insurance Entry
33=CHKD Federal EI Entry
34=CHKD Federal Pension Entry
35=CHKD Federal Health Entry
36=CHKD Federal Other Entry
41=CHKD State Income Entry
42=CHKD State Insurance Entry
43=CHKD State EI Entry
44=CHKD State Pension Entry
45=CHKD State Health Entry
46=CHKD State Other Entry
51=CHKD Local Income Entry
52=CHKD Local Insurance Entry
53=CHKD Local EI Entry
54=CHKD Local Pension Entry
55=CHKD Local Health Entry
56=CHKD Local Other Entry
61=CHKD User Income Entry
62=CHKD User Insurance Entry
63=CHKD User EI Entry
64=CHKD User Pension Entry
65=CHKD User Health Entry
66=CHKD User Other Entry
71=CHKD Exp Reimbursement
72=CHKD Cash Advance
73=CHKD Reported Tips
74=CHKD Allocated Tips
75=CHKD Noncash Advance
76=CHKD Vac Accrual
77=CHKD Sick Accrual
78=CHKD Comp Accrual
81=CHKD Cash Benefit
82=CHKD Noncash Benefit
PCONTENTS  Integer  Print Line Contents  List: 5 entries
1=CHKD Employee Only
2=CHKD Both EmpE And EmpR
3=CHKD Employer Only
4=CHKD Historical Entry
5=CHKD Tax Info Only Entry
TAXNONPER  BCD*10.3  Taxable Non-periodic Earnings   
TAXEARNBD  BCD*10.3  Subject to Income tax befor dedu   
POOLEDTIPS  BCD*10.3  Pooled Tips   
DETAILDATE  Date  Detail Date   
STARTTIME  Integer  Start Time   
STOPTIME  Integer  Stop Time   
WCCGROUP  String*6  Workers Comp. Group  Mask: %-6N
VALUES  Long  Number of Optional Fields   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.